Use Index

Create index file for a composite table as using index can increase performance.

Click CTX -> Index -> New to enter the following Index window:

Name: The index name.

Hash Length: The length of a hash index.

Filter Expression: The condition according to which the filtering operation is performed. It can be absent; default is to retrieve the whole set.

Index Type: Types of indexes include full-text index, hash index and ordered index.

Indexed Fields: Fields on which the index is created.

Value Fields: For an ordered index created on the indexed fields, the corresponding value fields will be written to it, too.

To set the Index Type as Hash Index, for example, the Indexed Fields is set as EID.

Click Execute button to finish creating the index.

Click CTX -> Index -> View Data to view the created index. To view the above index file, for example: